Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 66541 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 4 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 55.0 MiB |
| Average record size in memory | 867.1 B |
Variable types
| Text | 6 |
|---|---|
| DateTime | 3 |
| Unsupported | 1 |
| Categorical | 7 |
| Numeric | 7 |
Taxes (GST) has constant value "" | Constant |
| Dataset has 4 (< 0.1%) duplicate rows | Duplicates |
Booking Price[SGD] is highly overall correlated with Hotel Rating | High correlation |
Hotel Rating is highly overall correlated with Booking Price[SGD] | High correlation |
No. Of People is highly overall correlated with Rooms | High correlation |
Rooms is highly overall correlated with No. Of People | High correlation |
Time is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Discount has 2547 (3.8%) zeros | Zeros |
Reproduction
| Analysis started | 2024-02-28 13:58:11.508334 |
|---|---|
| Analysis finished | 2024-02-28 13:58:34.704642 |
| Duration | 23.2 seconds |
| Software version | ydata-profiling vv4.6.5 |
| Download configuration | config.json |
Booking ID
Text
| Distinct | 66536 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Characters and Unicode
| Total characters | 598869 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 66532 ? |
|---|---|
| Unique (%) | > 99.9% |
Sample
| 1st row | DDMY00001 |
|---|---|
| 2nd row | DDID00002 |
| 3rd row | DDSG00003 |
| 4th row | DDSG00004 |
| 5th row | DDKH00005 |
| Value | Count | Frequency (%) |
| ddvn34340 | 3 | < 0.1% |
| ddsg22537 | 2 | < 0.1% |
| ddkh50738 | 2 | < 0.1% |
| ddmy00008 | 2 | < 0.1% |
| ddvn00031 | 1 | < 0.1% |
| ddkh00034 | 1 | < 0.1% |
| ddvn00033 | 1 | < 0.1% |
| ddsg00017 | 1 | < 0.1% |
| ddsg00003 | 1 | < 0.1% |
| ddsg00004 | 1 | < 0.1% |
| Other values (66526) | 66526 |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 145068 | |
| 2 | 37016 | 6.2% |
| 3 | 37016 | 6.2% |
| 0 | 37016 | 6.2% |
| 1 | 37014 | 6.2% |
| 4 | 37008 | 6.2% |
| 5 | 36943 | 6.2% |
| 6 | 32978 | 5.5% |
| 7 | 25906 | 4.3% |
| 8 | 25905 | 4.3% |
| Other values (13) | 146999 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 332705 | |
| Uppercase Letter | 266164 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 145068 | |
| H | 24507 | 9.2% |
| T | 12170 | 4.6% |
| M | 12050 | 4.5% |
| Y | 12050 | 4.5% |
| G | 12037 | 4.5% |
| S | 12037 | 4.5% |
| I | 11986 | 4.5% |
| P | 6383 | 2.4% |
| V | 5961 | 2.2% |
| Other values (3) | 11915 | 4.5% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 37016 | |
| 3 | 37016 | |
| 0 | 37016 | |
| 1 | 37014 | |
| 4 | 37008 | |
| 5 | 36943 | |
| 6 | 32978 | |
| 7 | 25906 | |
| 8 | 25905 | |
| 9 | 25903 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 332705 | |
| Latin | 266164 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 145068 | |
| H | 24507 | 9.2% |
| T | 12170 | 4.6% |
| M | 12050 | 4.5% |
| Y | 12050 | 4.5% |
| G | 12037 | 4.5% |
| S | 12037 | 4.5% |
| I | 11986 | 4.5% |
| P | 6383 | 2.4% |
| V | 5961 | 2.2% |
| Other values (3) | 11915 | 4.5% |
Common
| Value | Count | Frequency (%) |
| 2 | 37016 | |
| 3 | 37016 | |
| 0 | 37016 | |
| 1 | 37014 | |
| 4 | 37008 | |
| 5 | 36943 | |
| 6 | 32978 | |
| 7 | 25906 | |
| 8 | 25905 | |
| 9 | 25903 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 598869 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| D | 145068 | |
| 2 | 37016 | 6.2% |
| 3 | 37016 | 6.2% |
| 0 | 37016 | 6.2% |
| 1 | 37014 | 6.2% |
| 4 | 37008 | 6.2% |
| 5 | 36943 | 6.2% |
| 6 | 32978 | 5.5% |
| 7 | 25906 | 4.3% |
| 8 | 25905 | 4.3% |
| Other values (13) | 146999 |
Date of Booking
Date
| Distinct | 3652 |
|---|---|
| Distinct (%) | 5.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 520.0 KiB |
| Minimum | 2010-01-01 00:00:00 |
|---|---|
| Maximum | 2019-12-31 00:00:00 |
Time
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 3.0 MiB |
Customer ID
Text
| Distinct | 66536 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 465787 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 66532 ? |
|---|---|
| Unique (%) | > 99.9% |
Sample
| 1st row | MY00001 |
|---|---|
| 2nd row | ID00001 |
| 3rd row | SG00001 |
| 4th row | SG00002 |
| 5th row | KH00001 |
| Value | Count | Frequency (%) |
| vn03010 | 3 | < 0.1% |
| sg04062 | 2 | < 0.1% |
| kh04520 | 2 | < 0.1% |
| my00002 | 2 | < 0.1% |
| vn00003 | 1 | < 0.1% |
| kh00004 | 1 | < 0.1% |
| vn00004 | 1 | < 0.1% |
| sg00005 | 1 | < 0.1% |
| sg00001 | 1 | < 0.1% |
| sg00002 | 1 | < 0.1% |
| Other values (66526) | 66526 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 89500 | |
| 1 | 39342 | 8.4% |
| 2 | 27298 | 5.9% |
| 3 | 27019 | 5.8% |
| 4 | 26927 | 5.8% |
| 5 | 26822 | 5.8% |
| H | 24506 | 5.3% |
| 6 | 24279 | 5.2% |
| 7 | 23883 | 5.1% |
| 8 | 23873 | 5.1% |
| Other values (13) | 132338 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 332705 | |
| Uppercase Letter | 133082 | 28.6% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 24506 | |
| T | 12170 | |
| Y | 12050 | |
| M | 12050 | |
| G | 12037 | |
| S | 12037 | |
| D | 11987 | |
| I | 11986 | |
| P | 6383 | 4.8% |
| V | 5961 | 4.5% |
| Other values (3) | 11915 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 89500 | |
| 1 | 39342 | |
| 2 | 27298 | 8.2% |
| 3 | 27019 | 8.1% |
| 4 | 26927 | 8.1% |
| 5 | 26822 | 8.1% |
| 6 | 24279 | 7.3% |
| 7 | 23883 | 7.2% |
| 8 | 23873 | 7.2% |
| 9 | 23762 | 7.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 332705 | |
| Latin | 133082 | 28.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| H | 24506 | |
| T | 12170 | |
| Y | 12050 | |
| M | 12050 | |
| G | 12037 | |
| S | 12037 | |
| D | 11987 | |
| I | 11986 | |
| P | 6383 | 4.8% |
| V | 5961 | 4.5% |
| Other values (3) | 11915 |
Common
| Value | Count | Frequency (%) |
| 0 | 89500 | |
| 1 | 39342 | |
| 2 | 27298 | 8.2% |
| 3 | 27019 | 8.1% |
| 4 | 26927 | 8.1% |
| 5 | 26822 | 8.1% |
| 6 | 24279 | 7.3% |
| 7 | 23883 | 7.2% |
| 8 | 23873 | 7.2% |
| 9 | 23762 | 7.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 465787 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 89500 | |
| 1 | 39342 | 8.4% |
| 2 | 27298 | 5.9% |
| 3 | 27019 | 5.8% |
| 4 | 26927 | 5.8% |
| 5 | 26822 | 5.8% |
| H | 24506 | 5.3% |
| 6 | 24279 | 5.2% |
| 7 | 23883 | 5.1% |
| 8 | 23873 | 5.1% |
| Other values (13) | 132338 |
Gender
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| Female | |
|---|---|
| Male |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.0035317 |
| Min length | 4 |
Characters and Unicode
| Total characters | 332940 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Male |
|---|---|
| 2nd row | Female |
| 3rd row | Female |
| 4th row | Male |
| 5th row | Male |
Common Values
| Value | Count | Frequency (%) |
| Female | 33388 | |
| Male | 33153 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| female | 33388 | |
| male | 33153 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 99929 | |
| a | 66541 | |
| l | 66541 | |
| F | 33388 | 10.0% |
| m | 33388 | 10.0% |
| M | 33153 | 10.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 266399 | |
| Uppercase Letter | 66541 | 20.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 99929 | |
| a | 66541 | |
| l | 66541 | |
| m | 33388 | 12.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 33388 | |
| M | 33153 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 332940 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 99929 | |
| a | 66541 | |
| l | 66541 | |
| F | 33388 | 10.0% |
| m | 33388 | 10.0% |
| M | 33153 | 10.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 332940 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 99929 | |
| a | 66541 | |
| l | 66541 | |
| F | 33388 | 10.0% |
| m | 33388 | 10.0% |
| M | 33153 | 10.0% |
Age
Real number (ℝ)
| Distinct | 41 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.436182 |
| Minimum | -5 |
|---|---|
| Maximum | 58 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 520.0 KiB |
Quantile statistics
| Minimum | -5 |
|---|---|
| 5-th percentile | 21 |
| Q1 | 28 |
| median | 38 |
| Q3 | 48 |
| 95-th percentile | 57 |
| Maximum | 58 |
| Range | 63 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 11.557562 |
|---|---|
| Coefficient of variation (CV) | 0.30069486 |
| Kurtosis | -1.199354 |
| Mean | 38.436182 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 0.010175915 |
| Sum | 2557582 |
| Variance | 133.57725 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 22 | 1776 | 2.7% |
| 56 | 1754 | 2.6% |
| 25 | 1742 | 2.6% |
| 28 | 1735 | 2.6% |
| 44 | 1732 | 2.6% |
| 47 | 1726 | 2.6% |
| 46 | 1723 | 2.6% |
| 19 | 1722 | 2.6% |
| 58 | 1721 | 2.6% |
| 33 | 1715 | 2.6% |
| Other values (31) | 49195 |
| Value | Count | Frequency (%) |
| -5 | 1 | < 0.1% |
| 19 | 1722 | |
| 20 | 1601 | |
| 21 | 1645 | |
| 22 | 1776 | |
| 23 | 1630 | |
| 24 | 1645 | |
| 25 | 1742 | |
| 26 | 1651 | |
| 27 | 1647 |
| Value | Count | Frequency (%) |
| 58 | 1721 | |
| 57 | 1611 | |
| 56 | 1754 | |
| 55 | 1617 | |
| 54 | 1671 | |
| 53 | 1598 | |
| 52 | 1607 | |
| 51 | 1659 | |
| 50 | 1651 | |
| 49 | 1594 |
Origin Country
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
| Thailand | |
|---|---|
| Malaysia | |
| Singapore | |
| Indonesia | |
| Philippines | |
| Other values (2) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 8.5592342 |
| Min length | 7 |
Characters and Unicode
| Total characters | 569540 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Malaysia |
|---|---|
| 2nd row | Indonesia |
| 3rd row | Singapore |
| 4th row | Singapore |
| 5th row | Cambodia |
Common Values
| Value | Count | Frequency (%) |
| Thailand | 12170 | |
| Malaysia | 12050 | |
| Singapore | 12038 | |
| Indonesia | 11986 | |
| Philippines | 6383 | |
| Vietnam | 5961 | |
| Cambodia | 5953 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| thailand | 12170 | |
| malaysia | 12050 | |
| singapore | 12038 | |
| indonesia | 11986 | |
| philippines | 6383 | |
| vietnam | 5961 | |
| cambodia | 5953 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 102381 | |
| i | 79307 | |
| n | 60524 | |
| e | 36368 | 6.4% |
| l | 30603 | 5.4% |
| s | 30419 | 5.3% |
| d | 30109 | 5.3% |
| o | 29977 | 5.3% |
| p | 24804 | 4.4% |
| h | 18553 | 3.3% |
| Other values (13) | 126495 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 502999 | |
| Uppercase Letter | 66541 | 11.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 102381 | |
| i | 79307 | |
| n | 60524 | |
| e | 36368 | 7.2% |
| l | 30603 | 6.1% |
| s | 30419 | 6.0% |
| d | 30109 | 6.0% |
| o | 29977 | 6.0% |
| p | 24804 | 4.9% |
| h | 18553 | 3.7% |
| Other values (6) | 59954 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 12170 | |
| M | 12050 | |
| S | 12038 | |
| I | 11986 | |
| P | 6383 | |
| V | 5961 | |
| C | 5953 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 569540 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 102381 | |
| i | 79307 | |
| n | 60524 | |
| e | 36368 | 6.4% |
| l | 30603 | 5.4% |
| s | 30419 | 5.3% |
| d | 30109 | 5.3% |
| o | 29977 | 5.3% |
| p | 24804 | 4.4% |
| h | 18553 | 3.3% |
| Other values (13) | 126495 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 569540 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 102381 | |
| i | 79307 | |
| n | 60524 | |
| e | 36368 | 6.4% |
| l | 30603 | 5.4% |
| s | 30419 | 5.3% |
| d | 30109 | 5.3% |
| o | 29977 | 5.3% |
| p | 24804 | 4.4% |
| h | 18553 | 3.3% |
| Other values (13) | 126495 |
State
Text
| Distinct | 219 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
Length
| Max length | 14 |
|---|---|
| Median length | 11 |
| Mean length | 7.4767887 |
| Min length | 3 |
Characters and Unicode
| Total characters | 497513 |
|---|---|
| Distinct characters | 50 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Johor |
|---|---|
| 2nd row | Ciawi |
| 3rd row | Central |
| 4th row | North |
| 5th row | Phnom Trop |
| Value | Count | Frequency (%) |
| central | 4821 | 5.7% |
| west | 2617 | 3.1% |
| sarawak | 1884 | 2.2% |
| johor | 1863 | 2.2% |
| penang | 1847 | 2.2% |
| north | 1799 | 2.1% |
| selangor | 1793 | 2.1% |
| thani | 1757 | 2.1% |
| north-east | 1461 | 1.7% |
| chonburi | 1350 | 1.6% |
| Other values (262) | 63007 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 80820 | |
| n | 45842 | 9.2% |
| e | 29429 | 5.9% |
| o | 29161 | 5.9% |
| r | 28803 | 5.8% |
| h | 25047 | 5.0% |
| t | 24806 | 5.0% |
| g | 19896 | 4.0% |
| i | 18063 | 3.6% |
| u | 17867 | 3.6% |
| Other values (40) | 177779 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 392734 | |
| Uppercase Letter | 85660 | 17.2% |
| Space Separator | 17658 | 3.5% |
| Dash Punctuation | 1461 | 0.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 80820 | |
| n | 45842 | |
| e | 29429 | 7.5% |
| o | 29161 | 7.4% |
| r | 28803 | 7.3% |
| h | 25047 | 6.4% |
| t | 24806 | 6.3% |
| g | 19896 | 5.1% |
| i | 18063 | 4.6% |
| u | 17867 | 4.5% |
| Other values (14) | 73000 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 13064 | |
| C | 10127 | |
| P | 10118 | |
| T | 9002 | |
| N | 7380 | |
| K | 5443 | 6.4% |
| B | 4565 | 5.3% |
| M | 4318 | 5.0% |
| E | 3100 | 3.6% |
| L | 2863 | 3.3% |
| Other values (14) | 15680 |
Space Separator
| Value | Count | Frequency (%) |
| 17658 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1461 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 478394 | |
| Common | 19119 | 3.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 80820 | |
| n | 45842 | 9.6% |
| e | 29429 | 6.2% |
| o | 29161 | 6.1% |
| r | 28803 | 6.0% |
| h | 25047 | 5.2% |
| t | 24806 | 5.2% |
| g | 19896 | 4.2% |
| i | 18063 | 3.8% |
| u | 17867 | 3.7% |
| Other values (38) | 158660 |
Common
| Value | Count | Frequency (%) |
| 17658 | ||
| - | 1461 | 7.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 497513 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 80820 | |
| n | 45842 | 9.2% |
| e | 29429 | 5.9% |
| o | 29161 | 5.9% |
| r | 28803 | 5.8% |
| h | 25047 | 5.0% |
| t | 24806 | 5.0% |
| g | 19896 | 4.0% |
| i | 18063 | 3.6% |
| u | 17867 | 3.6% |
| Other values (40) | 177779 |
Location
Text
| Distinct | 228 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
Length
| Max length | 23 |
|---|---|
| Median length | 15 |
| Mean length | 9.3061721 |
| Min length | 4 |
Characters and Unicode
| Total characters | 619242 |
|---|---|
| Distinct characters | 52 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Iskandar Puteri |
|---|---|
| 2nd row | West Java |
| 3rd row | Rochor |
| 4th row | Yishun |
| 5th row | Pursat |
| Value | Count | Frequency (%) |
| jakarta | 3519 | 3.3% |
| java | 3082 | 2.9% |
| west | 2425 | 2.3% |
| binh | 1700 | 1.6% |
| east | 1605 | 1.5% |
| central | 1512 | 1.4% |
| papua | 1458 | 1.4% |
| nakhon | 1281 | 1.2% |
| kampong | 1112 | 1.0% |
| kuching | 985 | 0.9% |
| Other values (284) | 87950 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 105023 | |
| n | 46782 | 7.6% |
| 40088 | 6.5% | |
| e | 34273 | 5.5% |
| o | 30788 | 5.0% |
| r | 30421 | 4.9% |
| t | 30245 | 4.9% |
| i | 29229 | 4.7% |
| h | 26787 | 4.3% |
| g | 23069 | 3.7% |
| Other values (42) | 222537 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 471537 | |
| Uppercase Letter | 107080 | 17.3% |
| Space Separator | 40088 | 6.5% |
| Dash Punctuation | 537 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 105023 | |
| n | 46782 | |
| e | 34273 | 7.3% |
| o | 30788 | 6.5% |
| r | 30421 | 6.5% |
| t | 30245 | 6.4% |
| i | 29229 | 6.2% |
| h | 26787 | 5.7% |
| g | 23069 | 4.9% |
| u | 22760 | 4.8% |
| Other values (15) | 92160 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 12758 | |
| P | 10874 | |
| K | 10104 | 9.4% |
| J | 9634 | 9.0% |
| T | 9035 | 8.4% |
| C | 7855 | 7.3% |
| B | 6973 | 6.5% |
| M | 5500 | 5.1% |
| N | 5259 | 4.9% |
| W | 3552 | 3.3% |
| Other values (14) | 25536 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 462 | |
| ‑ | 75 | 14.0% |
Space Separator
| Value | Count | Frequency (%) |
| 40088 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 578617 | |
| Common | 40625 | 6.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 105023 | |
| n | 46782 | 8.1% |
| e | 34273 | 5.9% |
| o | 30788 | 5.3% |
| r | 30421 | 5.3% |
| t | 30245 | 5.2% |
| i | 29229 | 5.1% |
| h | 26787 | 4.6% |
| g | 23069 | 4.0% |
| u | 22760 | 3.9% |
| Other values (39) | 199240 |
Common
| Value | Count | Frequency (%) |
| 40088 | ||
| - | 462 | 1.1% |
| ‑ | 75 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 618943 | |
| Latin 1 Sup | 224 | < 0.1% |
| Punctuation | 75 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 105023 | |
| n | 46782 | 7.6% |
| 40088 | 6.5% | |
| e | 34273 | 5.5% |
| o | 30788 | 5.0% |
| r | 30421 | 4.9% |
| t | 30245 | 4.9% |
| i | 29229 | 4.7% |
| h | 26787 | 4.3% |
| g | 23069 | 3.7% |
| Other values (40) | 222238 |
Latin 1 Sup
| Value | Count | Frequency (%) |
| ñ | 224 |
Punctuation
| Value | Count | Frequency (%) |
| ‑ | 75 |
Destination Country
Categorical
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| New Zealand | 3448 |
|---|---|
| Nepal | 3446 |
| Egypt | 3423 |
| Colombia | 3408 |
| China | 3391 |
| Other values (15) |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 6.2133572 |
| Min length | 4 |
Characters and Unicode
| Total characters | 413443 |
|---|---|
| Distinct characters | 35 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Denmark |
|---|---|
| 2nd row | Colombia |
| 3rd row | Germany |
| 4th row | Canada |
| 5th row | Kenya |
Common Values
| Value | Count | Frequency (%) |
| New Zealand | 3448 | 5.2% |
| Nepal | 3446 | 5.2% |
| Egypt | 3423 | 5.1% |
| Colombia | 3408 | 5.1% |
| China | 3391 | 5.1% |
| Denmark | 3375 | 5.1% |
| Israel | 3356 | 5.0% |
| France | 3346 | 5.0% |
| Iceland | 3344 | 5.0% |
| Italy | 3342 | 5.0% |
| Other values (10) | 32662 |
Length
| Value | Count | Frequency (%) |
| new | 3448 | 4.9% |
| zealand | 3448 | 4.9% |
| nepal | 3446 | 4.9% |
| egypt | 3423 | 4.9% |
| colombia | 3408 | 4.9% |
| china | 3391 | 4.8% |
| denmark | 3375 | 4.8% |
| israel | 3356 | 4.8% |
| france | 3346 | 4.8% |
| iceland | 3344 | 4.8% |
| Other values (11) | 36004 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 73226 | |
| e | 40135 | 9.7% |
| n | 39803 | 9.6% |
| l | 30166 | 7.3% |
| r | 23107 | 5.6% |
| d | 19995 | 4.8% |
| i | 19853 | 4.8% |
| I | 19821 | 4.8% |
| y | 13299 | 3.2% |
| C | 10130 | 2.5% |
| Other values (25) | 123908 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 340006 | |
| Uppercase Letter | 69989 | 16.9% |
| Space Separator | 3448 | 0.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 73226 | |
| e | 40135 | |
| n | 39803 | |
| l | 30166 | |
| r | 23107 | 6.8% |
| d | 19995 | 5.9% |
| i | 19853 | 5.8% |
| y | 13299 | 3.9% |
| p | 10124 | 3.0% |
| m | 10084 | 3.0% |
| Other values (12) | 60214 |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 19821 | |
| C | 10130 | |
| N | 6894 | 9.9% |
| M | 6522 | 9.3% |
| Z | 3448 | 4.9% |
| E | 3423 | 4.9% |
| D | 3375 | 4.8% |
| F | 3346 | 4.8% |
| G | 3301 | 4.7% |
| J | 3255 | 4.7% |
| Other values (2) | 6474 | 9.3% |
Space Separator
| Value | Count | Frequency (%) |
| 3448 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 409995 | |
| Common | 3448 | 0.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 73226 | |
| e | 40135 | 9.8% |
| n | 39803 | 9.7% |
| l | 30166 | 7.4% |
| r | 23107 | 5.6% |
| d | 19995 | 4.9% |
| i | 19853 | 4.8% |
| I | 19821 | 4.8% |
| y | 13299 | 3.2% |
| C | 10130 | 2.5% |
| Other values (24) | 120460 |
Common
| Value | Count | Frequency (%) |
| 3448 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 413443 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 73226 | |
| e | 40135 | 9.7% |
| n | 39803 | 9.6% |
| l | 30166 | 7.3% |
| r | 23107 | 5.6% |
| d | 19995 | 4.8% |
| i | 19853 | 4.8% |
| I | 19821 | 4.8% |
| y | 13299 | 3.2% |
| C | 10130 | 2.5% |
| Other values (25) | 123908 |
Destination City
Text
| Distinct | 120 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 MiB |
Length
| Max length | 14 |
|---|---|
| Median length | 11 |
| Mean length | 6.9708901 |
| Min length | 3 |
Characters and Unicode
| Total characters | 463850 |
|---|---|
| Distinct characters | 50 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Horsens |
|---|---|
| 2nd row | Medellin |
| 3rd row | Munich |
| 4th row | Montreal |
| 5th row | Nairobi |
| Value | Count | Frequency (%) |
| city | 1094 | 1.6% |
| hamilton | 1084 | 1.6% |
| bello | 646 | 0.9% |
| horizonte | 635 | 0.9% |
| belo | 635 | 0.9% |
| dublin | 628 | 0.9% |
| auckland | 624 | 0.9% |
| shanghai | 620 | 0.9% |
| toronto | 608 | 0.9% |
| haifa | 607 | 0.9% |
| Other values (115) | 62710 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 62260 | 13.4% |
| o | 35034 | 7.6% |
| e | 33275 | 7.2% |
| r | 33046 | 7.1% |
| i | 31744 | 6.8% |
| n | 29936 | 6.5% |
| l | 24615 | 5.3% |
| u | 18975 | 4.1% |
| t | 16942 | 3.7% |
| h | 13836 | 3.0% |
| Other values (40) | 164187 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 390609 | |
| Uppercase Letter | 69891 | 15.1% |
| Space Separator | 3350 | 0.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 62260 | |
| o | 35034 | 9.0% |
| e | 33275 | 8.5% |
| r | 33046 | 8.5% |
| i | 31744 | 8.1% |
| n | 29936 | 7.7% |
| l | 24615 | 6.3% |
| u | 18975 | 4.9% |
| t | 16942 | 4.3% |
| h | 13836 | 3.5% |
| Other values (16) | 90946 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 7102 | 10.2% |
| B | 6324 | 9.0% |
| H | 6095 | 8.7% |
| T | 5175 | 7.4% |
| A | 5059 | 7.2% |
| N | 4370 | 6.3% |
| C | 4363 | 6.2% |
| K | 3890 | 5.6% |
| S | 3867 | 5.5% |
| G | 3767 | 5.4% |
| Other values (13) | 19879 |
Space Separator
| Value | Count | Frequency (%) |
| 3350 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 460500 | |
| Common | 3350 | 0.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 62260 | 13.5% |
| o | 35034 | 7.6% |
| e | 33275 | 7.2% |
| r | 33046 | 7.2% |
| i | 31744 | 6.9% |
| n | 29936 | 6.5% |
| l | 24615 | 5.3% |
| u | 18975 | 4.1% |
| t | 16942 | 3.7% |
| h | 13836 | 3.0% |
| Other values (39) | 160837 |
Common
| Value | Count | Frequency (%) |
| 3350 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 463306 | |
| Latin 1 Sup | 544 | 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 62260 | 13.4% |
| o | 35034 | 7.6% |
| e | 33275 | 7.2% |
| r | 33046 | 7.1% |
| i | 31744 | 6.9% |
| n | 29936 | 6.5% |
| l | 24615 | 5.3% |
| u | 18975 | 4.1% |
| t | 16942 | 3.7% |
| h | 13836 | 3.0% |
| Other values (39) | 163643 |
Latin 1 Sup
| Value | Count | Frequency (%) |
| Ã | 544 |
No. Of People
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.995777 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 520.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.0000744 |
|---|---|
| Coefficient of variation (CV) | 0.50054706 |
| Kurtosis | -1.2494204 |
| Mean | 3.995777 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.0068885372 |
| Sum | 265883 |
| Variance | 4.0002978 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 9593 | |
| 4 | 9554 | |
| 7 | 9548 | |
| 3 | 9541 | |
| 1 | 9477 | |
| 5 | 9423 | |
| 6 | 9405 |
| Value | Count | Frequency (%) |
| 1 | 9477 | |
| 2 | 9593 | |
| 3 | 9541 | |
| 4 | 9554 | |
| 5 | 9423 | |
| 6 | 9405 | |
| 7 | 9548 |
| Value | Count | Frequency (%) |
| 7 | 9548 | |
| 6 | 9405 | |
| 5 | 9423 | |
| 4 | 9554 | |
| 3 | 9541 | |
| 2 | 9593 | |
| 1 | 9477 |
Check-in date
Date
| Distinct | 3747 |
|---|---|
| Distinct (%) | 5.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 520.0 KiB |
| Minimum | 2010-01-02 00:00:00 |
|---|---|
| Maximum | 2020-04-09 00:00:00 |
Number of Days
Real number (ℝ)
| Distinct | 70 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.2337656 |
| Minimum | 1 |
|---|---|
| Maximum | 97 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 520.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 8 |
| Maximum | 97 |
| Range | 96 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 3.3778544 |
|---|---|
| Coefficient of variation (CV) | 1.0445576 |
| Kurtosis | 116.33974 |
| Mean | 3.2337656 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 6.8337792 |
| Sum | 215178 |
| Variance | 11.4099 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 28254 | |
| 3 | 11506 | |
| 2 | 6648 | 10.0% |
| 7 | 6473 | 9.7% |
| 4 | 3888 | 5.8% |
| 8 | 2430 | 3.7% |
| 9 | 2406 | 3.6% |
| 5 | 2180 | 3.3% |
| 6 | 2176 | 3.3% |
| 12 | 47 | 0.1% |
| Other values (60) | 533 | 0.8% |
| Value | Count | Frequency (%) |
| 1 | 28254 | |
| 2 | 6648 | 10.0% |
| 3 | 11506 | |
| 4 | 3888 | 5.8% |
| 5 | 2180 | 3.3% |
| 6 | 2176 | 3.3% |
| 7 | 6473 | 9.7% |
| 8 | 2430 | 3.7% |
| 9 | 2406 | 3.6% |
| 10 | 39 | 0.1% |
| Value | Count | Frequency (%) |
| 97 | 2 | |
| 96 | 1 | |
| 93 | 1 | |
| 91 | 1 | |
| 90 | 1 | |
| 89 | 1 | |
| 88 | 1 | |
| 83 | 1 | |
| 82 | 1 | |
| 75 | 1 |
Check-Out Date
Date
| Distinct | 3748 |
|---|---|
| Distinct (%) | 5.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 520.0 KiB |
| Minimum | 2010-01-03 00:00:00 |
|---|---|
| Maximum | 2020-04-13 00:00:00 |
Rooms
Categorical
HIGH CORRELATION 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.7 MiB |
| 2 | |
|---|---|
| 1 | |
| 3 | |
| 4 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 66541 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 2 |
| 3rd row | 2 |
| 4th row | 2 |
| 5th row | 3 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 19095 | |
| 1 | 19070 | |
| 3 | 18828 | |
| 4 | 9548 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 19095 | |
| 1 | 19070 | |
| 3 | 18828 | |
| 4 | 9548 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 19095 | |
| 1 | 19070 | |
| 3 | 18828 | |
| 4 | 9548 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 66541 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 19095 | |
| 1 | 19070 | |
| 3 | 18828 | |
| 4 | 9548 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 66541 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 19095 | |
| 1 | 19070 | |
| 3 | 18828 | |
| 4 | 9548 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 66541 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 19095 | |
| 1 | 19070 | |
| 3 | 18828 | |
| 4 | 9548 |
Hotel Name
Text
| Distinct | 614 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.6 MiB |
Length
| Max length | 38 |
|---|---|
| Median length | 30 |
| Mean length | 15.208172 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1011967 |
|---|---|
| Distinct characters | 61 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Hotel Triton |
|---|---|
| 2nd row | Enchanted Isle |
| 3rd row | Seacoast Hotel |
| 4th row | Night In Paradise |
| 5th row | Tiny Digs Hotel |
| Value | Count | Frequency (%) |
| hotel | 18416 | 10.8% |
| the | 13232 | 7.8% |
| inn | 5403 | 3.2% |
| resort | 4887 | 2.9% |
| motel | 4261 | 2.5% |
| b&b | 3279 | 1.9% |
| suites | 2075 | 1.2% |
| hotels | 2028 | 1.2% |
| 1870 | 1.1% | |
| home | 1379 | 0.8% |
| Other values (690) | 113158 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 116560 | 11.5% |
| 103447 | 10.2% | |
| o | 79346 | 7.8% |
| t | 69017 | 6.8% |
| l | 61496 | 6.1% |
| a | 59176 | 5.8% |
| n | 50837 | 5.0% |
| r | 46314 | 4.6% |
| s | 44650 | 4.4% |
| i | 41829 | 4.1% |
| Other values (51) | 339295 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 729924 | |
| Uppercase Letter | 171613 | 17.0% |
| Space Separator | 103447 | 10.2% |
| Other Punctuation | 5232 | 0.5% |
| Final Punctuation | 1097 | 0.1% |
| Decimal Number | 335 | < 0.1% |
| Dash Punctuation | 319 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 116560 | |
| o | 79346 | |
| t | 69017 | |
| l | 61496 | |
| a | 59176 | |
| n | 50837 | 7.0% |
| r | 46314 | 6.3% |
| s | 44650 | 6.1% |
| i | 41829 | 5.7% |
| h | 23774 | 3.3% |
| Other values (17) | 136925 |
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 30729 | |
| T | 17285 | |
| B | 16317 | |
| S | 15621 | |
| R | 12470 | 7.3% |
| M | 11184 | 6.5% |
| C | 8489 | 4.9% |
| I | 8048 | 4.7% |
| P | 7542 | 4.4% |
| A | 5585 | 3.3% |
| Other values (16) | 38343 |
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 131 | |
| 5 | 102 | |
| 1 | 102 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 5149 | |
| . | 83 | 1.6% |
Space Separator
| Value | Count | Frequency (%) |
| 103447 |
Final Punctuation
| Value | Count | Frequency (%) |
| ’ | 1097 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 319 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 901537 | |
| Common | 110430 | 10.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 116560 | 12.9% |
| o | 79346 | 8.8% |
| t | 69017 | 7.7% |
| l | 61496 | 6.8% |
| a | 59176 | 6.6% |
| n | 50837 | 5.6% |
| r | 46314 | 5.1% |
| s | 44650 | 5.0% |
| i | 41829 | 4.6% |
| H | 30729 | 3.4% |
| Other values (43) | 301583 |
Common
| Value | Count | Frequency (%) |
| 103447 | ||
| & | 5149 | 4.7% |
| ’ | 1097 | 1.0% |
| - | 319 | 0.3% |
| 6 | 131 | 0.1% |
| 5 | 102 | 0.1% |
| 1 | 102 | 0.1% |
| . | 83 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1010776 | |
| Punctuation | 1097 | 0.1% |
| Latin 1 Sup | 94 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 116560 | 11.5% |
| 103447 | 10.2% | |
| o | 79346 | 7.9% |
| t | 69017 | 6.8% |
| l | 61496 | 6.1% |
| a | 59176 | 5.9% |
| n | 50837 | 5.0% |
| r | 46314 | 4.6% |
| s | 44650 | 4.4% |
| i | 41829 | 4.1% |
| Other values (49) | 338104 |
Punctuation
| Value | Count | Frequency (%) |
| ’ | 1097 |
Latin 1 Sup
| Value | Count | Frequency (%) |
| è | 94 |
Hotel Rating
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.2885003 |
| Minimum | 3.3 |
|---|---|
| Maximum | 4.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 520.0 KiB |
Quantile statistics
| Minimum | 3.3 |
|---|---|
| 5-th percentile | 3.8 |
| Q1 | 4.2 |
| median | 4.3 |
| Q3 | 4.5 |
| 95-th percentile | 4.6 |
| Maximum | 4.7 |
| Range | 1.4 |
| Interquartile range (IQR) | 0.3 |
Descriptive statistics
| Standard deviation | 0.2755163 |
|---|---|
| Coefficient of variation (CV) | 0.064245373 |
| Kurtosis | 1.7803154 |
| Mean | 4.2885003 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | -1.166679 |
| Sum | 285361.1 |
| Variance | 0.075909234 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.2 | 12425 | |
| 4.6 | 10725 | |
| 4.5 | 9681 | |
| 4.3 | 9349 | |
| 4.4 | 8376 | |
| 4.1 | 6570 | |
| 3.8 | 4134 | 6.2% |
| 3.9 | 1355 | 2.0% |
| 3.7 | 1347 | 2.0% |
| 3.3 | 1296 | 1.9% |
| Value | Count | Frequency (%) |
| 3.3 | 1296 | 1.9% |
| 3.7 | 1347 | 2.0% |
| 3.8 | 4134 | 6.2% |
| 3.9 | 1355 | 2.0% |
| 4.1 | 6570 | |
| 4.2 | 12425 | |
| 4.3 | 9349 | |
| 4.4 | 8376 | |
| 4.5 | 9681 | |
| 4.6 | 10725 |
| Value | Count | Frequency (%) |
| 4.7 | 1283 | 1.9% |
| 4.6 | 10725 | |
| 4.5 | 9681 | |
| 4.4 | 8376 | |
| 4.3 | 9349 | |
| 4.2 | 12425 | |
| 4.1 | 6570 | |
| 3.9 | 1355 | 2.0% |
| 3.8 | 4134 | 6.2% |
| 3.7 | 1347 | 2.0% |
Payment Mode
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.2 MiB |
| Internet Banking | |
|---|---|
| Debit Card | |
| Wallet | |
| Credit Card | |
| COD |
Length
| Max length | 16 |
|---|---|
| Median length | 10 |
| Mean length | 9.22813 |
| Min length | 3 |
Characters and Unicode
| Total characters | 614049 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Wallet |
|---|---|
| 2nd row | Wallet |
| 3rd row | Credit Card |
| 4th row | Debit Card |
| 5th row | Wallet |
Common Values
| Value | Count | Frequency (%) |
| Internet Banking | 13446 | |
| Debit Card | 13363 | |
| Wallet | 13317 | |
| Credit Card | 13267 | |
| COD | 13148 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| card | 26630 | |
| internet | 13446 | |
| banking | 13446 | |
| debit | 13363 | |
| wallet | 13317 | |
| credit | 13267 | |
| cod | 13148 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 66839 | |
| e | 66839 | |
| n | 53784 | |
| a | 53393 | |
| r | 53343 | |
| C | 53045 | |
| i | 40076 | 6.5% |
| 40076 | 6.5% | |
| d | 39897 | 6.5% |
| l | 26634 | 4.3% |
| Other values (8) | 120123 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 441060 | |
| Uppercase Letter | 132913 | 21.6% |
| Space Separator | 40076 | 6.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 66839 | |
| e | 66839 | |
| n | 53784 | |
| a | 53393 | |
| r | 53343 | |
| i | 40076 | |
| d | 39897 | |
| l | 26634 | 6.0% |
| g | 13446 | 3.0% |
| k | 13446 | 3.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 53045 | |
| D | 26511 | |
| I | 13446 | 10.1% |
| B | 13446 | 10.1% |
| W | 13317 | 10.0% |
| O | 13148 | 9.9% |
Space Separator
| Value | Count | Frequency (%) |
| 40076 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 573973 | |
| Common | 40076 | 6.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 66839 | |
| e | 66839 | |
| n | 53784 | |
| a | 53393 | |
| r | 53343 | |
| C | 53045 | |
| i | 40076 | |
| d | 39897 | |
| l | 26634 | 4.6% |
| D | 26511 | 4.6% |
| Other values (7) | 93612 |
Common
| Value | Count | Frequency (%) |
| 40076 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 614049 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 66839 | |
| e | 66839 | |
| n | 53784 | |
| a | 53393 | |
| r | 53343 | |
| C | 53045 | |
| i | 40076 | 6.5% |
| 40076 | 6.5% | |
| d | 39897 | 6.5% |
| l | 26634 | 4.3% |
| Other values (8) | 120123 |
Bank Name
Categorical
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| United Overseas Bank (UOB) | |
|---|---|
| Cash | |
| DBS Bank | |
| Bank of Singapore (BOS) | |
| HSBC | |
| Other values (4) |
Length
| Max length | 26 |
|---|---|
| Median length | 10 |
| Mean length | 10.599811 |
| Min length | 4 |
Characters and Unicode
| Total characters | 705322 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | United Overseas Bank (UOB) |
|---|---|
| 2nd row | EZ-Link |
| 3rd row | Grab |
| 4th row | DBS Paylah |
| 5th row | Bank of Singapore (BOS) |
Common Values
| Value | Count | Frequency (%) |
| United Overseas Bank (UOB) | 7500 | |
| Cash | 7491 | |
| DBS Bank | 7467 | |
| Bank of Singapore (BOS) | 7466 | |
| HSBC | 7379 | |
| DBS Paylah | 7330 | |
| CITI Bank | 7322 | |
| Grab | 7304 | |
| EZ-Link | 7282 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| bank | 29755 | |
| dbs | 14797 | |
| united | 7500 | 5.6% |
| overseas | 7500 | 5.6% |
| uob | 7500 | 5.6% |
| cash | 7491 | 5.6% |
| of | 7466 | 5.6% |
| singapore | 7466 | 5.6% |
| bos | 7466 | 5.6% |
| hsbc | 7379 | 5.5% |
| Other values (4) | 29238 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 74176 | 10.5% |
| 67017 | 9.5% | |
| B | 66897 | 9.5% |
| n | 52003 | 7.4% |
| S | 37108 | 5.3% |
| k | 37037 | 5.3% |
| e | 29966 | 4.2% |
| s | 22491 | 3.2% |
| O | 22466 | 3.2% |
| r | 22270 | 3.2% |
| Other values (26) | 273891 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 356806 | |
| Uppercase Letter | 244285 | |
| Space Separator | 67017 | 9.5% |
| Open Punctuation | 14966 | 2.1% |
| Close Punctuation | 14966 | 2.1% |
| Dash Punctuation | 7282 | 1.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 74176 | |
| n | 52003 | |
| k | 37037 | |
| e | 29966 | |
| s | 22491 | 6.3% |
| r | 22270 | 6.2% |
| i | 22248 | 6.2% |
| o | 14932 | 4.2% |
| h | 14821 | 4.2% |
| v | 7500 | 2.1% |
| Other values (8) | 59362 |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 66897 | |
| S | 37108 | |
| O | 22466 | 9.2% |
| C | 22192 | 9.1% |
| U | 15000 | 6.1% |
| D | 14797 | 6.1% |
| I | 14644 | 6.0% |
| H | 7379 | 3.0% |
| P | 7330 | 3.0% |
| T | 7322 | 3.0% |
| Other values (4) | 29150 |
Space Separator
| Value | Count | Frequency (%) |
| 67017 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 14966 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 14966 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 7282 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 601091 | |
| Common | 104231 | 14.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 74176 | 12.3% |
| B | 66897 | 11.1% |
| n | 52003 | 8.7% |
| S | 37108 | 6.2% |
| k | 37037 | 6.2% |
| e | 29966 | 5.0% |
| s | 22491 | 3.7% |
| O | 22466 | 3.7% |
| r | 22270 | 3.7% |
| i | 22248 | 3.7% |
| Other values (22) | 214429 |
Common
| Value | Count | Frequency (%) |
| 67017 | ||
| ( | 14966 | 14.4% |
| ) | 14966 | 14.4% |
| - | 7282 | 7.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 705322 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 74176 | 10.5% |
| 67017 | 9.5% | |
| B | 66897 | 9.5% |
| n | 52003 | 7.4% |
| S | 37108 | 5.3% |
| k | 37037 | 5.3% |
| e | 29966 | 4.2% |
| s | 22491 | 3.2% |
| O | 22466 | 3.2% |
| r | 22270 | 3.2% |
| Other values (26) | 273891 |
Booking Price[SGD]
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 491 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 214.04678 |
| Minimum | 35 |
|---|---|
| Maximum | 578 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 520.0 KiB |
Quantile statistics
| Minimum | 35 |
|---|---|
| 5-th percentile | 56 |
| Q1 | 125 |
| median | 199 |
| Q3 | 293 |
| 95-th percentile | 407 |
| Maximum | 578 |
| Range | 543 |
| Interquartile range (IQR) | 168 |
Descriptive statistics
| Standard deviation | 108.12618 |
|---|---|
| Coefficient of variation (CV) | 0.50515211 |
| Kurtosis | -0.70140534 |
| Mean | 214.04678 |
| Median Absolute Deviation (MAD) | 83 |
| Skewness | 0.38855539 |
| Sum | 14242887 |
| Variance | 11691.272 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 290 | 630 | 0.9% |
| 160 | 613 | 0.9% |
| 161 | 595 | 0.9% |
| 318 | 565 | 0.8% |
| 158 | 556 | 0.8% |
| 97 | 538 | 0.8% |
| 115 | 516 | 0.8% |
| 289 | 514 | 0.8% |
| 131 | 512 | 0.8% |
| 173 | 491 | 0.7% |
| Other values (481) | 61011 |
| Value | Count | Frequency (%) |
| 35 | 62 | 0.1% |
| 36 | 62 | 0.1% |
| 37 | 70 | 0.1% |
| 38 | 193 | |
| 39 | 72 | 0.1% |
| 40 | 169 | |
| 41 | 109 | |
| 42 | 139 | |
| 43 | 139 | |
| 44 | 146 |
| Value | Count | Frequency (%) |
| 578 | 2 | |
| 576 | 2 | |
| 575 | 1 | |
| 571 | 1 | |
| 568 | 1 | |
| 564 | 1 | |
| 562 | 1 | |
| 558 | 1 | |
| 554 | 1 | |
| 553 | 1 |
Discount
Real number (ℝ)
ZEROS 
| Distinct | 26 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.12546956 |
| Minimum | 0 |
|---|---|
| Maximum | 0.25 |
| Zeros | 2547 |
| Zeros (%) | 3.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 520.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.01 |
| Q1 | 0.06 |
| median | 0.13 |
| Q3 | 0.19 |
| 95-th percentile | 0.24 |
| Maximum | 0.25 |
| Range | 0.25 |
| Interquartile range (IQR) | 0.13 |
Descriptive statistics
| Standard deviation | 0.075112945 |
|---|---|
| Coefficient of variation (CV) | 0.59865473 |
| Kurtosis | -1.2068243 |
| Mean | 0.12546956 |
| Median Absolute Deviation (MAD) | 0.07 |
| Skewness | -0.010747477 |
| Sum | 8348.87 |
| Variance | 0.0056419545 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.2 | 2716 | 4.1% |
| 0.01 | 2660 | 4.0% |
| 0.09 | 2650 | 4.0% |
| 0.21 | 2634 | 4.0% |
| 0.12 | 2625 | 3.9% |
| 0.22 | 2624 | 3.9% |
| 0.19 | 2611 | 3.9% |
| 0.11 | 2603 | 3.9% |
| 0.23 | 2595 | 3.9% |
| 0.15 | 2587 | 3.9% |
| Other values (16) | 40236 |
| Value | Count | Frequency (%) |
| 0 | 2547 | |
| 0.01 | 2660 | |
| 0.02 | 2495 | |
| 0.03 | 2482 | |
| 0.04 | 2577 | |
| 0.05 | 2543 | |
| 0.06 | 2512 | |
| 0.07 | 2473 | |
| 0.08 | 2435 | |
| 0.09 | 2650 |
| Value | Count | Frequency (%) |
| 0.25 | 2575 | |
| 0.24 | 2529 | |
| 0.23 | 2595 | |
| 0.22 | 2624 | |
| 0.21 | 2634 | |
| 0.2 | 2716 | |
| 0.19 | 2611 | |
| 0.18 | 2493 | |
| 0.17 | 2462 | |
| 0.16 | 2460 |
Taxes (GST)
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 MiB |
| 0.07 |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 266164 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.07 |
|---|---|
| 2nd row | 0.07 |
| 3rd row | 0.07 |
| 4th row | 0.07 |
| 5th row | 0.07 |
Common Values
| Value | Count | Frequency (%) |
| 0.07 | 66541 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.07 | 66541 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 133082 | |
| . | 66541 | |
| 7 | 66541 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 199623 | |
| Other Punctuation | 66541 | 25.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 133082 | |
| 7 | 66541 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 66541 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 266164 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 133082 | |
| . | 66541 | |
| 7 | 66541 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 266164 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 133082 | |
| . | 66541 | |
| 7 | 66541 |
Profit Margin
Real number (ℝ)
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.18881652 |
| Minimum | 0.1 |
|---|---|
| Maximum | 0.3 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 520.0 KiB |
Quantile statistics
| Minimum | 0.1 |
|---|---|
| 5-th percentile | 0.1 |
| Q1 | 0.14 |
| median | 0.2 |
| Q3 | 0.23 |
| 95-th percentile | 0.28 |
| Maximum | 0.3 |
| Range | 0.2 |
| Interquartile range (IQR) | 0.09 |
Descriptive statistics
| Standard deviation | 0.05276504 |
|---|---|
| Coefficient of variation (CV) | 0.27945139 |
| Kurtosis | -0.86690274 |
| Mean | 0.18881652 |
| Median Absolute Deviation (MAD) | 0.04 |
| Skewness | 0.082602761 |
| Sum | 12564.04 |
| Variance | 0.0027841494 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.22 | 9358 | |
| 0.14 | 6853 | |
| 0.2 | 5409 | 8.1% |
| 0.24 | 5404 | 8.1% |
| 0.25 | 5356 | 8.0% |
| 0.13 | 5320 | 8.0% |
| 0.16 | 4075 | 6.1% |
| 0.1 | 4041 | 6.1% |
| 0.17 | 3305 | 5.0% |
| 0.19 | 3030 | 4.6% |
| Other values (7) | 14390 |
| Value | Count | Frequency (%) |
| 0.1 | 4041 | |
| 0.11 | 2744 | |
| 0.13 | 5320 | |
| 0.14 | 6853 | |
| 0.15 | 2547 | 3.8% |
| 0.16 | 4075 | |
| 0.17 | 3305 | |
| 0.18 | 1243 | 1.9% |
| 0.19 | 3030 | |
| 0.2 | 5409 |
| Value | Count | Frequency (%) |
| 0.3 | 2702 | 4.1% |
| 0.28 | 1296 | 1.9% |
| 0.25 | 5356 | |
| 0.24 | 5404 | |
| 0.23 | 2578 | 3.9% |
| 0.22 | 9358 | |
| 0.21 | 1280 | 1.9% |
| 0.2 | 5409 | |
| 0.19 | 3030 | 4.6% |
| 0.18 | 1243 | 1.9% |
| Age | Bank Name | Booking Price[SGD] | Destination Country | Discount | Gender | Hotel Rating | No. Of People | Number of Days | Origin Country | Payment Mode | Profit Margin | Rooms | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Age | 1.000 | 0.012 | -0.002 | 0.013 | 0.013 | 0.000 | -0.002 | 0.006 | -0.003 | 0.000 | 0.005 | 0.000 | 0.008 |
| Bank Name | 0.012 | 1.000 | -0.001 | 0.017 | 0.001 | 0.016 | 0.001 | 0.004 | -0.005 | 0.000 | 0.008 | 0.002 | 0.010 |
| Booking Price[SGD] | -0.002 | -0.001 | 1.000 | 0.010 | -0.002 | 0.000 | 0.541 | -0.000 | -0.039 | 0.000 | 0.000 | -0.154 | 0.008 |
| Destination Country | 0.013 | 0.017 | 0.010 | 1.000 | -0.006 | 0.014 | -0.002 | -0.002 | -0.006 | 0.005 | 0.015 | -0.003 | 0.006 |
| Discount | 0.013 | 0.001 | -0.002 | -0.006 | 1.000 | 0.012 | 0.005 | 0.005 | 0.000 | 0.000 | 0.009 | -0.003 | 0.010 |
| Gender | 0.000 | 0.016 | 0.000 | 0.014 | 0.012 | 1.000 | -0.003 | -0.005 | 0.001 | 0.000 | 0.014 | 0.006 | 0.010 |
| Hotel Rating | -0.002 | 0.001 | 0.541 | -0.002 | 0.005 | -0.003 | 1.000 | -0.002 | -0.008 | 0.000 | 0.010 | -0.371 | 0.011 |
| No. Of People | 0.006 | 0.004 | -0.000 | -0.002 | 0.005 | -0.005 | -0.002 | 1.000 | -0.003 | 0.001 | 0.006 | 0.006 | 1.000 |
| Number of Days | -0.003 | -0.005 | -0.039 | -0.006 | 0.000 | 0.001 | -0.008 | -0.003 | 1.000 | 0.000 | 0.007 | -0.002 | 0.002 |
| Origin Country | 0.000 | 0.000 | 0.000 | 0.005 | 0.000 | 0.000 | 0.000 | 0.001 | 0.000 | 1.000 | 0.002 | 0.005 | 0.000 |
| Payment Mode | 0.005 | 0.008 | 0.000 | 0.015 | 0.009 | 0.014 | 0.010 | 0.006 | 0.007 | 0.002 | 1.000 | 0.001 | 0.004 |
| Profit Margin | 0.000 | 0.002 | -0.154 | -0.003 | -0.003 | 0.006 | -0.371 | 0.006 | -0.002 | 0.005 | 0.001 | 1.000 | 0.012 |
| Rooms | 0.008 | 0.010 | 0.008 | 0.006 | 0.010 | 0.010 | 0.011 | 1.000 | 0.002 | 0.000 | 0.004 | 0.012 | 1.000 |
| Booking ID | Date of Booking | Time | Customer ID | Gender | Age | Origin Country | State | Location | Destination Country | Destination City | No. Of People | Check-in date | Number of Days | Check-Out Date | Rooms | Hotel Name | Hotel Rating | Payment Mode | Bank Name | Booking Price[SGD] | Discount | Taxes (GST) | Profit Margin | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | DDMY00001 | 2010-01-01 | 10:49:40 | MY00001 | Male | 42 | Malaysia | Johor | Iskandar Puteri | Denmark | Horsens | 1 | 2010-01-12 | 8 | 2010-01-20 | 1 | Hotel Triton | 4.3 | Wallet | United Overseas Bank (UOB) | 243 | 0.01 | 0.07 | 0.25 |
| 1 | DDID00002 | 2010-01-01 | 09:19:47 | ID00001 | Female | 44 | Indonesia | Ciawi | West Java | Colombia | Medellin | 3 | 2010-01-21 | 1 | 2010-01-22 | 2 | Enchanted Isle | 4.2 | Wallet | EZ-Link | 312 | 0.00 | 0.07 | 0.24 |
| 2 | DDSG00003 | 2010-01-01 | 11:52:56 | SG00001 | Female | 31 | Singapore | Central | Rochor | Germany | Munich | 3 | 2010-01-02 | 7 | 2010-01-09 | 2 | Seacoast Hotel | 4.5 | Credit Card | Grab | 338 | 0.19 | 0.07 | 0.20 |
| 3 | DDSG00004 | 2010-01-01 | 13:44:40 | SG00002 | Male | 28 | Singapore | North | Yishun | Canada | Montreal | 3 | 2010-02-15 | 4 | 2010-02-19 | 2 | Night In Paradise | 4.2 | Debit Card | DBS Paylah | 254 | 0.19 | 0.07 | 0.13 |
| 4 | DDKH00005 | 2010-01-01 | 05:38:26 | KH00001 | Male | 44 | Cambodia | Phnom Trop | Pursat | Kenya | Nairobi | 5 | 2010-01-03 | 3 | 2010-01-06 | 3 | Tiny Digs Hotel | 4.6 | Wallet | Bank of Singapore (BOS) | 313 | 0.15 | 0.07 | 0.17 |
| 5 | DDTH00006 | 2010-01-01 | 05:41:55 | TH00001 | Male | 32 | Thailand | Chiang Mai | Chiang Mai | Canada | Toronto | 2 | 2010-01-28 | 1 | 2010-01-29 | 1 | Seascape | 4.5 | Internet Banking | United Overseas Bank (UOB) | 161 | 0.01 | 0.07 | 0.15 |
| 6 | DDTH00007 | 2010-01-01 | 20:14:21 | TH00002 | Male | 49 | Thailand | Surat Thani | Surat Thani | Iran | Tehran | 3 | 2010-03-15 | 3 | 2010-03-18 | 2 | Waldorf Astoria | 4.6 | Debit Card | HSBC | 313 | 0.10 | 0.07 | 0.17 |
| 7 | DDMY00008 | 2010-01-01 | 00:22:07 | MY00002 | Female | 58 | Malaysia | Sarawak | Kuching | Egypt | Port Said | 4 | 2010-01-03 | 1 | 2010-01-04 | 2 | The Westgate Hotel | 4.1 | Wallet | Cash | 121 | 0.05 | 0.07 | 0.15 |
| 8 | DDSG00009 | 2010-01-01 | 09:30:32 | SG00003 | Male | 57 | Singapore | North | Mandai | Egypt | Luxor | 4 | 2010-04-09 | 3 | 2010-04-12 | 2 | Firefly Motel | 4.4 | COD | EZ-Link | 173 | 0.20 | 0.07 | 0.22 |
| 9 | DDSG00010 | 2010-01-01 | 16:22:39 | SG00004 | Female | 41 | Singapore | West | Tengah | France | Marseille | 4 | 2010-01-07 | 2 | 2010-01-09 | 2 | Cape Grace | 4.7 | Credit Card | Grab | 309 | 0.16 | 0.07 | 0.25 |
| Booking ID | Date of Booking | Time | Customer ID | Gender | Age | Origin Country | State | Location | Destination Country | Destination City | No. Of People | Check-in date | Number of Days | Check-Out Date | Rooms | Hotel Name | Hotel Rating | Payment Mode | Bank Name | Booking Price[SGD] | Discount | Taxes (GST) | Profit Margin | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 66531 | DDVN66526 | 2019-12-31 | 15:27:30 | VN05957 | Male | 52 | Vietnam | Phan Thiet | Binh Thuan | Israel | Holon | 2 | 2020-01-01 | 1 | 2020-01-02 | 1 | Slumber Falls | 3.8 | Debit Card | Grab | 115 | 0.07 | 0.07 | 0.25 |
| 66532 | DDID66527 | 2019-12-31 | 04:18:40 | ID11986 | Female | 30 | Indonesia | Senayan | Jakarta | Israel | Beersheba | 4 | 2020-03-28 | 1 | 2020-03-29 | 2 | Creek Quest | 3.8 | COD | DBS Paylah | 120 | 0.00 | 0.07 | 0.22 |
| 66533 | DDMY66528 | 2019-12-31 | 17:53:01 | MY12048 | Male | 46 | Malaysia | Kedah | Alor Setar | Canada | Ottawa | 5 | 2020-01-01 | 3 | 2020-01-04 | 3 | Hotel Triton | 4.1 | Credit Card | HSBC | 159 | 0.14 | 0.07 | 0.22 |
| 66534 | DDVN66529 | 2019-12-31 | 04:31:42 | VN05958 | Female | 19 | Vietnam | Dien Ban | Quang Nam | Maldives | Thinadhoo | 1 | 2020-01-01 | 1 | 2020-01-02 | 1 | The Hot Springs Hotel | 3.8 | Internet Banking | Bank of Singapore (BOS) | 116 | 0.14 | 0.07 | 0.22 |
| 66535 | DDMY66530 | 2019-12-31 | 04:15:03 | MY12049 | Male | 46 | Malaysia | Johor | Johor Bahru | Iceland | Reykjavik | 3 | 2020-01-09 | 1 | 2020-01-10 | 2 | Hotel The Pie | 4.2 | Debit Card | DBS Bank | 181 | 0.15 | 0.07 | 0.10 |
| 66536 | DDSG66531 | 2019-12-31 | 23:36:16 | SG12034 | Female | 42 | Singapore | Central | Orchard | Germany | Berlin | 4 | 2020-01-06 | 4 | 2020-01-10 | 2 | Silver Cloud Inn | 4.3 | Wallet | Grab | 182 | 0.23 | 0.07 | 0.24 |
| 66537 | DDSG66532 | 2019-12-31 | 14:41:01 | SG12035 | Female | 54 | Singapore | Central | Geylang | Israel | Holon | 4 | 2020-04-09 | 4 | 2020-04-13 | 2 | The Elet | 4.2 | COD | DBS Paylah | 125 | 0.06 | 0.07 | 0.19 |
| 66538 | DDSG66533 | 2019-12-31 | 19:11:16 | SG12036 | Female | 57 | Singapore | Central | Downtown Core | Canada | Ottawa | 7 | 2020-01-09 | 1 | 2020-01-10 | 4 | The Elet | 4.4 | Debit Card | EZ-Link | 318 | 0.02 | 0.07 | 0.22 |
| 66539 | DDTH66534 | 2019-12-31 | 05:12:29 | TH12170 | Female | 44 | Thailand | Surat Thani | Ko Samui | Maldives | Viligili | 3 | 2020-01-01 | 1 | 2020-01-02 | 2 | Sunset Lodge | 4.2 | Debit Card | HSBC | 173 | 0.14 | 0.07 | 0.25 |
| 66540 | DDVN66535 | 2019-12-31 | 00:51:52 | VN05959 | Female | 52 | Vietnam | Pleiku | Gia Lai | Egypt | Luxor | 5 | 2020-01-24 | 4 | 2020-01-28 | 3 | Coastal bay hotel | 4.3 | Internet Banking | Grab | 182 | 0.17 | 0.07 | 0.24 |
Most frequently occurring
| Booking ID | Date of Booking | Customer ID | Gender | Age | Origin Country | State | Location | Destination Country | Destination City | No. Of People | Check-in date | Number of Days | Check-Out Date | Rooms | Hotel Name | Hotel Rating | Payment Mode | Bank Name | Booking Price[SGD] | Discount | Taxes (GST) | Profit Margin | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3 | DDVN34340 | 2016-02-23 | VN03010 | Male | 38 | Vietnam | Pleiku | Gia Lai | Italy | Rome | 4 | 2016-03-19 | 4 | 2016-03-23 | 2 | Hotel Lucia | 4.4 | Credit Card | HSBC | 170 | 0.10 | 0.07 | 0.22 | 3 |
| 0 | DDKH50738 | 2018-04-14 | KH04520 | Male | 46 | Cambodia | Krang Yov | Kandal | New Zealand | Dunedin | 4 | 2018-04-23 | 7 | 2018-04-30 | 2 | The Fresco Hotel | 3.8 | Internet Banking | EZ-Link | 99 | 0.06 | 0.07 | 0.22 | 2 |
| 1 | DDMY00008 | 2010-01-01 | MY00002 | Female | 58 | Malaysia | Sarawak | Kuching | Egypt | Port Said | 4 | 2010-01-03 | 1 | 2010-01-04 | 2 | The Westgate Hotel | 4.1 | Wallet | Cash | 121 | 0.05 | 0.07 | 0.15 | 2 |
| 2 | DDSG22537 | 2014-03-23 | SG04062 | Male | 41 | Singapore | Central | Geylang | Germany | Essen | 2 | 2014-03-24 | 1 | 2014-03-25 | 1 | Royal Orbit | 4.2 | Wallet | HSBC | 48 | 0.17 | 0.07 | 0.19 | 2 |